Show All

Open an XML data file

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

1. Click File, and then click Open.
2. In the Look in list, click the drive, folder, or Internet location that contains the file you want to open.
3. In the folder list, locate and open the folder that contains the file.
4. Click the file, and then click Open.

   The Open XML dialog box appears.

5. Select one of the following options and then click OK.

   As an XML list

   An XML list is created in a new workbook.

   The contents of the file are imported into the XML list. If the XML data file does not refer to a schema, then Microsoft Excel will infer the schema of the XML data file.

   As a read-only workbook

   The XML data file is opened as a read-only workbook. The structure of the file is flattened.

   Use the XML Source task pane

   The schema of the XML data file is displayed in the XML Source task pane. You can then drag elements of the schema to the worksheet to map those elements to the worksheet.

   If you are opening an XML data file that does not refer to a schema, then Excel will infer the schema of the XML data file.